{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["COC1","COC2","Instructions","Sheet1"],"not_rendered":{"charts":0,"images":36,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"COC1","index":0,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[35,7,36,9],[35,0,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,6],[32,7,33,9],[34,7,34,9],[31,0,31,2],[31,7,31,9],[32,4,33,4],[32,0,33,2],[32,3,33,3],[34,0,34,2],[34,5,34,6],[31,5,31,6],[32,5,33,6],[35,15,36,19],[35,20,36,26],[31,10,31,14],[31,15,31,19],[31,20,31,26],[32,10,33,14],[32,15,33,19],[32,20,33,26],[34,20,34,26],[34,10,34,14],[34,15,34,19],[35,10,36,14],[30,22,30,26],[27,0,27,1],[27,7,27,26],[18,5,18,8],[28,20,29,26],[12,5,12,7],[29,0,29,1],[29,3,30,8],[25,2,25,8],[26,0,26,1],[25,0,25,1],[26,2,26,8],[24,26,26,26],[24,0,24,1],[20,5,20,8],[23,5,23,8],[19,5,19,8],[21,5,21,8],[10,0,12,0],[6,23,13,23],[6,24,13,24],[7,0,8,0],[6,1,6,3],[6,5,6,7],[0,22,0,23],[0,25,0,26],[0,20,0,21],[28,9,30,19],[0,13,0,19],[27,2,27,6],[0,4,0,8],[5,0,5,3],[2,21,2,24],[6,13,13,13],[6,10,13,10],[4,2,4,3],[1,9,1,26],[5,9,5,25],[5,26,13,26],[2,10,2,14],[28,0,28,2],[6,25,13,25],[6,20,13,20],[17,5,17,8],[22,5,22,8],[24,2,24,8],[9,5,9,7],[9,1,9,3],[10,5,10,7],[16,5,16,8],[14,5,14,8],[15,5,15,8],[13,5,13,8],[10,1,12,3],[7,1,7,3],[8,1,8,3],[8,5,8,7],[2,7,2,8],[3,10,3,14],[2,16,2,19],[3,16,3,19],[6,21,13,21],[6,22,13,22],[6,14,13,14],[6,12,13,12],[6,11,13,11],[4,10,4,14],[5,4,5,8],[3,4,3,8],[6,9,13,9],[6,19,13,19],[3,21,3,24],[6,18,13,18],[4,16,4,20],[4,21,4,26],[6,17,13,17],[6,16,13,16],[6,15,13,15],[7,5,7,7],[6,8,12,8],[11,5,11,7]]}
[null,null,null,null,"CHAIN OF CUSTODY",null,null,null,null,"ESS Lab #",null,null,null,null,null,null,null,null,null,null,"Page",null,1,null,"of",{"$f":"IF(W1=\"\",\"\",IF('COC2'!B15=\"\",1,2))","v":1}]
[null,null,null,null,"  Turn Time (Days)",null,null,null,null,"ELECTRONIC DELIVERABLES (Final Reports are PDF)"]
[null,null,null,null,"Regulatory State:",null,"Criteria:",null,null,null,"Limit Checker",null,null,null,null,null,"State Forms",null,null,null,null,"EQuIS"]
[null,null,null,null,"Is this project for any of the following?:",null,null,null,null,null,"Excel",null,null,null,null,null,"Hard Copy",null,null,null,null,"Enviro Data"]
[null,null,null,null,false,false,false,false,false,null,"CLP-Like Package",null,null,null,null,null,"Other (Specify) →"]
["CLIENT INFORMATION",null,null,null,"PROJECT INFORMATION",null,null,null,null,"REQUESTED ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Number of Bottles"]
["Client:",null,null,null,"Project Name:",null,null,null,"Client acknowledges that sampling is compliant with all EPA / State regulatory programs"]
["Address:",null,null,null,"Project Location:"]
[null,null,null,null,"Project Number:"]
["Phone:",null,null,null,"Project Manager:"]
["Email Distribution List:",null,null,null,"Bill to:"]
[null,null,null,null,"PO#:"]
[null,null,null,null,"Quote#:"]
["ESS Lab ID","Collection Date","Collection Time","Sample Type","Sample Matrix","Sample ID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Container Type:",null,"AC-Air Cassette     AG-Amber Glass     B-BOD Bottle     C-Cubitainer      J-Jar     O-Other     P-Poly     S-Sterile    V-Vial",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(AA15:AA24)=0,\"\",SUM(AA15:AA24))","v":""}]
["Container Volume:",null,"1-100 mL     2-2.5 gal     3-250 mL     4-300 mL    5-500 mL     6-1L     7-VOA     8-2 oz     9-4 oz     10-8 oz     11-Other*"]
["Preservation Code:",null,"1-Non Preserved   2-HCl   3-H2SO4   4-HNO3   5-NaOH   6-Methanol   7-Na2S2O3   8-ZnAce, NaOH   9-NH4Cl   10-DI H2O   11-Other*"]
["Sampled by :",null,null,null,null,null,null,"Chain needs to be filled out neatly and completely for on time delivery."]
["Laboratory Use Only",null,null,"Comments:","* Please specify \"Other\" preservative and containers types in this space",null,null,null,null,"All samples submitted are subject to ESS Laboratory's payment terms and conditions.",null,null,null,null,null,null,null,null,null,null,"Dissolved Filtration"]
["Cooler Temperature (℃):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Lab Filter"]
["Relinquished by (Signature)",null,null,"Date","Time","Received by (Signature)",null,"Relinquished by (Signature)",null,null,"Date",null,null,null,null,"Time",null,null,null,null,"Received by (Signature)"]
[]
[]
["Relinquished by (Signature)",null,null,"Date","Time","Received by (Signature)",null,"Relinquished by (Signature)",null,null,"Date",null,null,null,null,"Time",null,null,null,null,"Received by (Signature)"]

{"sheet":"COC2","index":1,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[35,15,36,19],[35,20,36,26],[35,0,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,6],[35,7,36,9],[35,10,36,14],[32,15,33,19],[32,20,33,26],[34,0,34,2],[34,5,34,6],[34,7,34,9],[34,10,34,14],[34,15,34,19],[34,20,34,26],[32,0,33,2],[32,3,33,3],[32,4,33,4],[32,5,33,6],[32,7,33,9],[32,10,33,14],[28,9,30,19],[28,20,29,26],[30,22,30,26],[31,0,31,2],[31,5,31,6],[31,7,31,9],[31,10,31,14],[31,15,31,19],[31,20,31,26],[28,0,28,2],[29,3,30,8],[29,0,29,1],[24,26,26,26],[25,0,25,1],[25,2,25,8],[26,0,26,1],[26,2,26,8],[27,0,27,1],[27,2,27,6],[27,7,27,26],[20,5,20,8],[21,5,21,8],[22,5,22,8],[23,5,23,8],[24,0,24,1],[24,2,24,8],[14,5,14,8],[15,5,15,8],[16,5,16,8],[17,5,17,8],[18,5,18,8],[19,5,19,8],[10,5,10,7],[11,5,11,7],[12,5,12,7],[10,1,12,3],[7,5,7,7],[8,5,8,7],[9,1,9,3],[9,5,9,7],[6,20,13,20],[6,21,13,21],[6,22,13,22],[6,8,12,8],[6,9,13,9],[6,10,13,10],[6,11,13,11],[6,12,13,12],[6,13,13,13],[13,5,13,8],[7,1,8,3],[3,4,3,8],[3,10,3,14],[3,16,3,19],[3,21,3,24],[4,2,4,3],[4,10,4,14],[4,16,4,20],[4,21,4,26],[5,0,5,3],[5,4,5,8],[5,9,5,25],[5,26,13,26],[6,1,6,3],[6,5,6,7],[6,23,13,23],[6,24,13,24],[6,25,13,25],[6,14,13,14],[6,15,13,15],[6,16,13,16],[6,17,13,17],[6,18,13,18],[6,19,13,19],[10,0,12,0],[0,4,0,8],[0,13,0,19],[0,20,0,21],[0,22,0,23],[0,25,0,26],[1,9,1,26],[2,10,2,14],[2,16,2,19],[2,21,2,24],[2,7,2,8]]}
[null,null,null,null,"CHAIN OF CUSTODY",null,null,null,null,"ESS Lab #",null,null,null,null,null,null,null,null,null,null,"Page",null,2,null,"of",2]
[null,null,null,null,"  Turn Time",null,null,null,null,"ELECTRONIC DELIVERABLES (Final Reports are PDF)"]
[null,null,null,null,"Regulatory State:",null,"Criteria:",null,null,null,"Limit Checker",null,null,null,null,null,"State Forms",null,null,null,null,"EQuIS"]
[null,null,null,null,"Is this project for any of the following?:",null,null,null,null,null,"Excel",null,null,null,null,null,"Hard Copy",null,null,null,null,"Enviro Data"]
[null,null,null,null,false,false,false,false,false,null,"CLP-Like Package",null,null,null,null,null,"Other (Specify) →"]
["CLIENT INFORMATION",null,null,null,"PROJECT INFORMATION",null,null,null,null,"REQUESTED ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Number of Bottles"]
["Client:",null,null,null,"Project Name:",null,null,null,"Client acknowledges that sampling is compliant with all EPA / State regulatory programs"]
["Address:",null,null,null,"Project Location:"]
[null,null,null,null,"Project Number:"]
["Phone:",null,null,null,"Project Manager:"]
["Email Distribution List:",null,null,null,"Bill to:"]
[null,null,null,null,"PO#:"]
[null,null,null,null,"Quote#:"]
["ESS Lab ID","Collection Date","Collection Time","Sample Type","Sample Matrix","Sample ID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Container Type:",null,"AC-Air Cassette     AG-Amber Glass     B-BOD Bottle     C-Cubitainer      J-Jar     O-Other     P-Poly     S-Sterile    V-Vial",null,null,null,null,null,null,"","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(AA15:AA24)=0,\"\",SUM(AA15:AA24))","v":""}]
["Container Volume:",null,"1-100 mL     2-2.5 gal     3-250 mL     4-300 mL    5-500 mL     6-1L     7-VOA     8-2 oz     9-4 oz     10-8 oz     11-Other*"]
["Preservation Code:",null,"1-Non Preserved   2-HCl   3-H2SO4   4-HNO3   5-NaOH   6-Methanol   7-Na2S2O3   8-ZnAce, NaOH   9-NH4Cl   10-DI H2O   11-Other*"]
["Sampled by :",null,null,null,null,null,null,"Chain needs to be filled out neatly and completely for on time delivery."]
["Laboratory Use Only",null,null,"Comments:","* Please specify \"Other\" preservative and containers types in this space",null,null,null,null,"All samples submitted are subject to ESS Laboratory's payment terms and conditions.",null,null,null,null,null,null,null,null,null,null,"Dissolved Filtration"]
["Cooler Temperature (℃):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Lab Filter"]
["Relinquished by (Signature)",null,null,"Date","Time","Received by (Signature)",null,"Relinquished by (Signature)",null,null,"Date",null,null,null,null,"Time",null,null,null,null,"Received by (Signature)"]
[]
[]
["Relinquished by (Signature)",null,null,"Date","Time","Received by (Signature)",null,"Relinquished by (Signature)",null,null,"Date",null,null,null,null,"Time",null,null,null,null,"Received by (Signature)"]

{"sheet":"Instructions","index":2,"n_rows":47,"n_cols":36,"rows_kept":47,"cut":false,"hidden":false,"merged":[[17,13,17,29],[17,30,25,30],[18,16,25,16],[18,17,25,17],[19,5,20,7],[41,7,42,12],[12,29,12,30],[13,13,13,30],[14,11,14,12],[14,14,14,18],[14,20,14,23],[14,25,14,28],[15,8,15,12],[15,14,15,18],[15,20,15,23],[15,25,15,28],[12,8,12,12],[12,17,12,23],[12,24,12,25],[12,26,12,27],[16,6,16,7],[16,14,16,18],[16,20,16,24],[16,25,16,30],[17,4,17,7],[17,8,17,12],[23,9,23,11],[24,9,24,11],[18,5,18,7],[18,9,18,11],[18,27,25,27],[18,28,25,28],[18,29,25,29],[18,18,25,18],[18,19,25,19],[18,20,25,20],[18,21,25,21],[18,22,25,22],[18,23,25,23],[19,9,19,11],[20,9,20,11],[21,5,21,7],[21,9,21,11],[18,24,25,24],[18,25,25,25],[18,26,25,26],[18,12,24,12],[18,13,25,13],[18,14,25,14],[18,15,25,15],[22,4,24,4],[22,5,24,7],[36,30,38,30],[37,4,37,5],[37,6,37,12],[38,4,38,5],[38,6,38,12],[25,9,25,12],[26,9,26,12],[27,9,27,12],[28,9,28,12],[29,9,29,12],[30,9,30,12],[31,9,31,12],[22,9,22,11],[39,4,39,5],[39,6,39,10],[39,11,39,30],[32,9,32,12],[33,9,33,12],[34,9,34,12],[35,9,35,12],[36,4,36,5],[36,6,36,12],[40,13,42,23],[40,24,41,30],[42,26,42,30],[43,4,43,6],[43,9,43,10],[43,11,43,13],[43,14,43,18],[43,19,43,23],[43,24,43,30],[40,4,40,6],[41,4,41,5],[47,19,48,23],[47,24,48,30],[47,4,48,6],[47,7,48,7],[47,8,48,8],[47,9,48,10],[47,11,48,13],[47,14,48,18],[44,19,45,23],[44,24,45,30],[46,4,46,6],[46,9,46,10],[46,11,46,13],[46,14,46,18],[46,19,46,23],[46,24,46,30],[44,4,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,10],[44,11,45,13],[44,14,45,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"CHAIN OF CUSTODY",null,null,null,null,"ESS Lab #",null,null,null,null,null,null,null,null,null,null,"Page",null,null,null,"of",null,null,"Sample Type","Matrix","TAT","Checkbox Value","Checkbox Label"]
[null,null,null,null,null,null,null,null,"Turn Time",null,null,null,null,"ELECTRONIC DATA DELIVERABLE (EDD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,"Limit Checker"]
[null,null,null,null,null,null,null,null,"Regulatory State:",null,"Criteria:",null,null,null,"Limit Checker",null,null,null,null,null,"State Forms",null,null,null,null,"EQuIS",null,null,null,null,null,"Grab","Ground Water",false,false,"State Forms"]
[null,null,null,null,null,null,null,null,"Is this project for any of the following?:",null,null,null,null,null,"Excel",null,null,null,null,null,"Hard Copy",null,null,null,null,"Enviro Data",null,null,null,null,null,"Composite","Waste Water",false,false,"EQuIS"]
[null,null,null,null,null,null,null,null,false,false,null,false,false,null,"CLP-Like Package",null,null,null,null,null,"Other (Specify) →",null,null,null,null,null,null,null,null,null,null,"Grab/Composite","Drinking Water",false,false,"Excel"]
[null,null,null,null,"CLIENT INFORMATION",null,null,null,"PROJECT INFORMATION",null,null,null,null,"REQUESTED ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Number of Bottles","Trip Blank","Surface Water",false,false,"Hard Copy"]
[null,null,null,null,"Client:",null,null,null,"Project Name:",null,null,null,"Client acknowledges that sampling is compliant with all EPA / State regulatory programs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment Blank","Soil",false,false,"Envrio Data"]
[null,null,null,null,"Address:",null,null,null,"Project Location:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Field Sample","Solid",false,false,"CLP"]
[null,null,null,null,null,null,null,null,"Project Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wipe",null,false,"Other"]
[null,null,null,null,"Phone:",null,null,null,"Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil",null,false,"Lab Filter"]
[null,null,null,null,"Email Distribution List:",null,null,null,"Bill to:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter"]
[null,null,null,null,null,null,null,null,"PO#:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aqueous"]
[null,null,null,null,null,null,null,null,"Quote#:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air"]
[null,null,null,null,"ESS Lab ID","Collection Date","Collection Time","Sample Type","Sample Matrix","Sample ID"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Container Type:",null,"AC-Air Cassette     AG-Amber Glass     B-BOD Bottle     C-Cubitainer      J-Jar     O-Other     P-Poly     S-Sterile    V-Vial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AE27:AE36)=0,\"\",SUM(AE27:AE36))","v":""}]
[null,null,null,null,"Container Volume:",null,"1-100 mL     2-2.5 gal     3-250 mL     4-300 mL    5-500 mL     6-1L     7-VOA     8-2 oz     9-4 oz     10-8 oz     11-Other*"]
[null,null,null,null,"Preservation Code:",null,"1-Non Preserved   2-HCl   3-H2SO4   4-HNO3   5-NaOH   6-Methanol   7-Na2S2O3   8-ZnAce, NaOH   9-NH4Cl   10-DI H2O   11-Other*"]
[null,null,null,null,"Sampled by :",null,null,null,null,null,null,"Chain needs to be filled out neatly and completely for on time delivery."]
[null,null,null,null,"Laboratory Use Only",null,null,"Comments:","* Please specify \"Other\" preservative and containers types in this space",null,null,null,null,"All samples submitted are subject to ESS Laboratory's payment terms and conditions.",null,null,null,null,null,null,null,null,null,null,"Dissolved Filtration"]
[null,null,null,null,"Cooler Temperature (℃):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Lab Filter"]
[null,null,null,null,"Relinquished by (Signature)",null,null,"Date","Time","Received by (Signature)",null,"Relinquished by (Signature)",null,null,"Date",null,null,null,null,"Time",null,null,null,null,"Received by (Signature)"]
[]
[]
[null,null,null,null,"Relinquished by (Signature)",null,null,"Date","Time","Received by (Signature)",null,"Relinquished by (Signature)",null,null,"Date",null,null,null,null,"Time",null,null,null,null,"Received by (Signature)"]

{"sheet":"Sheet1","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Sample Type","Matrix","TAT Value","TAT Label","EDD Checkbox Value","EDD Checkbox Label","Project Type Value","Project Type Label"]
[null,null,false,"> 5",false,"Limit Checker",false,"CT-RCP"]
["Grab","Ground Water",false,5,false,"State Forms",false,"MA-MCP"]
["Composite","Waste Water",false,4,false,"EQuIS",false,"RGP"]
["Grab/Composite","Drinking Water",false,3,false,"Excel",false,"Permit"]
["Trip Blank","Surface Water",false,2,false,"Hard Copy",false,"401 WQ"]
["Equipment Blank","Soil",false,1,false,"Envrio Data"]
["Field Sample","Solid",false,"Same Day",false,"CLP"]
[null,"Wipe",null,null,false,"Other"]
[null,"Oil",null,null,false,"Lab Filter"]
[null,"Filter"]
[null,"Aqueous"]
[null,"Air"]